The original ESP GUI was a Java application that was connected to a SQL database. Here are the use instructions for that application (some links don't work).

1. MBARI Central DB: Use this one if you want to run the GUI against the central MBARI database hosted on a Microsoft SQL Server.
   1. Launch using JNLP
   2. Download the GUI Application and launch by:
      1. Command line: 'java -jar esp-gui-0.2-SNAPSHOT-jar-with-dependencies.jar'
      2. Or you should be able to double click on the jar in most cases.
2. Localhost: Download this version if you want to run the GUI and have it point to a local installation of a MySQL database
   1. Download the localhost version of the application
   2. If you have not setup the mysql database before, you will need to use the command line mysql client to create the database, user and assign permissions. Do the following as root on a local installation of mysql

      takoda:~ kgomes$ mysql --user=root --password=
      Enter password:
      mysql> CREATE DATABASE esp;
      mysql> CREATE USER 'espdba'@'localhost' IDENTIFIED BY 'leghorn';
      mysql> GRANT ALL PRIVILEGES ON esp.* TO 'espdba'@'localhost' WITH GRANT OPTION;
      mysql> quit
      

   3. Launch the application either by command line with

      java -jar esp-gui-0.2-SNAPSHOT-localhost-jar-with-dependencies.jar
      

      or you should be able to double click on the jar in most cases.